﻿
create view "Quarterly Orders" AS
SELECT DISTINCT [Clients].CustomerID, [Clients].CompanyName, [Clients].City, [Clients].Country
FROM [Clients] RIGHT JOIN Orders ON [Clients].CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN '19970101' And '19971231'
